Business Intelligence · Portfolio performance lens

Where should 3M defend, reshape, and reinvest - by segment and by region?

Using public 3M annual report data (2020–2024), this dashboard separates structural direction (CAGR) from annual volatility (YoY) to support portfolio decisions: protect & invest where momentum is stronger, and reshape & prune where decline is persistent.

Scope: 2020–2024 · USD (millions)
Total net sales (2020 → 2024)
$34.3B → $24.3B
Overall CAGR: -8.3% · 2024 YoY: -0.9%
Best segment momentum
Health Care
CAGR: 8.4% · Prioritise margin + share defence
Most pressured region
Europe, Middle East and Africa
CAGR: -9.1% · Tighten ROI gates and refocus GTM
Key view
Scale × Momentum
Prioritise “big + improving” pockets, avoid “small + worsening” traps

Executive Dashboard

Interaction: hover for detail, click legend to isolate. CAGR charts are ranked to highlight portfolio priorities.

Quick reference table

2024 scale, YoY, and CAGR to support discussion and recommendations.

CategoryName2024 Net Sales (USD, M)2024 YoYCAGR 2020–2024

Business question: What is the 2024 portfolio mix by segment?

Segment mix (2024) — Treemap

Composition by segment using 2024 net sales totals (Health Care excluded where not reported).

Business question: How is 2024 revenue distributed across regions?

Region mix (2024) — Donut

Share across Americas, Asia Pacific, and EMEA (Worldwide excluded).

Business question: Is top-line contraction flattening?

Total net sales (aggregate)

Sum of available segment series for consistent year comparisons.

Business question: Which areas combine scale and momentum?

Scale vs momentum (2024 net sales vs CAGR)

Top-right: higher priority. Bottom-left: candidates for rationalisation.

Business question: Which segments are stabilising vs declining across 2020–2024?

Net sales by business segment

Time-series view. Use legend toggles to compare trajectories.

Business question: Which segments fit “protect & invest” vs “reshape & prune”?

Segment CAGR (2020–2024)

Ranked structural signal. Negative values indicate long-run pressure.

Business question: Where is geographic demand stabilising vs shrinking?

Net sales by geographic region

Excludes “Worldwide” roll-up to avoid double counting.

Business question: Which regions should receive focus vs containment?

Regional CAGR (2020–2024)

Ranked structural signal by region.

The Story Behind the Data

What question is answered, why it matters, and how the analysis was constructed.

Business context

  • In diversified companies, portfolio decisions are best made using segment × region signals, not only the company total.
  • This dashboard isolates structural direction (CAGR) and near-term momentum (YoY) to guide actions.

Data & methodology

  • Data source: 3M annual report net sales tables (2020–2024) for segments and regions.
  • Governance: no personal data; aggregated financial figures only; “Worldwide” roll-up removed for regions.
  • Analytics: time-series trends, YoY change, CAGR, and a prioritisation scatter (scale vs momentum).

Insights & Recommendations

Written as decisions: what we saw, why it matters, and what to do next.

Portfolio signal: pressure is structural

  • Negative CAGR across multiple areas implies multi-year headwinds beyond short-term noise.
  • Action should focus on mix, pricing, and portfolio design, not only cost reduction.

Prioritisation: scale + trend

  • Use the scatter to identify “big + improving/least-negative” pockets for priority focus.
  • Deprioritise “small + worsening” areas that consume effort without payback.

Region lens: ROI gates

  • Regions with deepest negative trend require stricter ROI gating and channel redesign.
  • Reallocate to regions with comparatively stronger stability signals.
Decision zone

Prescriptive actions (Do / Don’t)

Do (next 2 quarters)

  • Protect & invest where trend is strongest (or least negative) and scale is material.
  • Reshape & prune steeper-decline areas via SKU rationalisation and price/mix optimisation.
  • Regional triage: deploy ROI gates in pressured regions; rebuild channel strategy with measurable payback.

Don’t (avoid common traps)

  • Don’t chase volume in structurally declining areas at the expense of margin.
  • Don’t apply blanket cuts that weaken areas with better momentum signals.
  • Don’t double count regional totals using “Worldwide” roll-ups.
Limitations: net sales ≠ profit; FX/inflation effects; segment definitions may change; aggregation hides subcategory performance.

Execution scoreboard (next 12–18 months)

Converts insights into measurable actions. Targets are directional and should be refined with margin, mix and cost data.

Initiative Primary KPI Target Leading indicator
Stabilise pressured segments (Consumer + T&E) Net sales YoY Improve to ≤ -1% by FY2025 Top-50 SKU rationalisation completed
Reinvest in scale + momentum (top-right of matrix) Mix shift to growth segments +2–3 pp share of 2024 sales by FY2026 Pipeline / win-rate uplift in priority pockets
Regional ROI gating (focus on weakest CAGR regions) Regional CAGR Reduce decline rate by 2 pp by FY2026 GTM spend reallocated to highest-return programs
How to use: review monthly; escalate when any KPI misses two consecutive periods.

Peer benchmarking snapshot

Adds external context to “scale vs momentum”.

Company Revenue CAGR (2020–2024) Notes / source
3M - Computed from this dashboard totals (Annual Reports 2020–2024)
Honeywell 3.3% FY2020–FY2024 Annual Report / 10-K
DuPont 2% FY2020–FY2024 Annual Report / 10-K
Tip: benchmarking is most useful when paired with a consistent definition (reported revenue vs net sales, FX treatment, and portfolio changes).

Forecast: baseline + scenarios (2025-2027)

Directional outlook from a simple linear trend on total net sales (2020-2024). Scenarios show ±1 RMSE around the baseline.

Interpretation note: This is not a full financial forecast. It doesn’t model divestitures, FX, macro cycles, or pricing/mix shifts; it’s a trend-based scenario frame.

Technical Documentation

Data sourcing, governance, reproducibility, and AI reflection (200–300 words).

Governance & reproducibility

  • Sources: 3M Annual Reports (2020–2024), net sales tables by segment and geographic area.
  • Quality checks: standardised formats; validated year coverage; excluded “Worldwide” regional roll-up to prevent double counting.
  • GDPR: no personal data used (aggregated financial data only).
  • Offline-ready: Plotly + data embedded into this single HTML file (no external files).

Validation (lightweight statistical check)

Backtest (train 2020–2023 → predict 2024)
Predicted 2024: - · Actual 2024: -
Absolute error: -
Fit quality (2020–2024)
RMSE: - · R²: -
Assumption: linear trend on total net sales (small sample, directional).

AI usage reflection

I used ChatGPT as my coding assistant/sidekick to speed up development and maintain clarity while retaining responsibility for correctness. I prompted for Plotly/JavaScript patterns to build multiple visuals from the data collected referring 3M's annual reports. I iterated prompts with explicit constraints (“single self-contained HTML”,“embed all data”, “offline-ready”, “include limitations and prescriptive actions”) and validated each change by checking that the outputs still represented the underlying figures. It took me a total of 14 versions of code development to create the final deliverable. One key challenge was governance and comparability: I removed the “Worldwide” regional roll-up to avoid double counting and used CAGR to separate structural signals from one-year spikes. ChatGPT generated code quickly, but I crosschecked calculations, ensured the visuals were accurate, and aligned the site content with the assignment brief. Overall, AI helped me prototype faster and polish, while the analytical decisions and validation werecompleted by me.